// 
// Decompiled by Procyon v0.5.36
// 

package com.orange.boot.dev2.mapper;

import com.orange.boot.dev2.entity.vo.CatalogueVO;
import java.util.List;
import com.orange.boot.dev2.entity.vo.DiseasePictureNameVO;
import com.orange.boot.dev2.entity.vo.ShowDiseaseInfoVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.orange.boot.dev2.entity.vo.BrowseParamsVO;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.orange.boot.dev2.entity.DiseaseInformation;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

public interface DiseaseInformationMapper extends BaseMapper<DiseaseInformation>
{
    @Select({ "SELECT disease_id,disease_chinese_name,disaster_type_name,disease_introduce,disease_symptom  FROM disease_information LEFT JOIN disaster_type on disaster_type.disaster_type_id = disease_information.disaster_type_id WHERE is_deleted = 0" })
    Page<BrowseParamsVO> browseParams(final Page<BrowseParamsVO> p0);
    
    Page<BrowseParamsVO> browseLike(final Page<BrowseParamsVO> p0, @Param("diseaseChineseName") final String p1, @Param("disasterTypeId") final String p2, @Param("citrusPartId") final String p3);
    
    @Select({ "SELECT disease_chinese_name,disease_english_name,disease_trivial_name,disaster_type_name,disease_pathogen,disease_introduce,disease_symptom,disease_treatment,disease_distribution,disease_video,disease_weight,disease_picture_url  FROM disease_information LEFT JOIN disaster_type ON disease_information.disaster_type_id =  disaster_type.disaster_type_id WHERE disease_id = #{disease_id} AND is_deleted = 0" })
    ShowDiseaseInfoVO showDiseaseInformation(final String p0);
    
    @Select({ " SELECT disease_id , disease_picture_url,LEFT (disease_symptom ,25) as disease_concise_description, disease_symptom  FROM disease_information WHERE is_deleted = 0 " })
    Page<DiseasePictureNameVO> showDiseasePictureName(final Page<DiseasePictureNameVO> p0);
    
    @Select({ "SELECT disease_chinese_name,disease_english_name,disease_trivial_name,disaster_type_name,disease_pathogen,disease_introduce,disease_symptom,disease_treatment,disease_distribution,disease_video,disease_weight,disease_picture_url  FROM disease_information LEFT JOIN disaster_type ON disease_information.disaster_type_id =  disaster_type.disaster_type_id WHERE disease_chinese_name like concat ( '%',#{diseaseChineseName},'%') AND is_deleted = 0" })
    List<ShowDiseaseInfoVO> diseaseForNameLike(final String p0);
    
    Page<DiseasePictureNameVO> diseaseLike(final Page<DiseasePictureNameVO> p0, @Param("diseaseChineseName") final String p1, @Param("disasterTypeId") final String p2, @Param("citrusPartId") final String p3);
    
    List<CatalogueVO> catalogue(@Param("disasterTypeId") final String p0, @Param("citrusPartId") final String p1);
}
